6.2.0 Release Notes OneStream

Release Date: September 15, 2020

Introduction

OneStream 6.2.0 is a minor release which contains new features, enhancements to existing features, and business rule API additions. The features of this type of release are developed to enhance the design capabilities, performance, and improve ease of use of applications. Designers, system administrators, and users, will benefit from the enhancements across their application. Minor versions are compatible with prior versions.

Important Notes

Prerequisites

Refer to Upgrade OneStream 6.2.0 for important notices and details regarding planning your upgrade.

Compatibility and Important Notices

Refer to Upgrade OneStream 6.2.0 for information on compatibility of the OneStream Studio and OneStream Excel Add-in versions.

OneStream users are encouraged to adopt the OneStream Windows App. The OneStream web interface has been developed using Microsoft’s Silverlight web browser plug-in.  Microsoft officially announced in 2012 that development of Silverlight will be discontinued with support ending in October 2021.  The OneStream Windows Application is the replacement for the Silverlight-based browser interface.  Customers should note that certain new features may only be available in the OneStream Windows App due to its technology advantages.  In addition, users can access OneStream through the HTML5-based OneStream Mobile and OneStream Excel Add-in.  OneStream will not support the Silverlight-based web browser interface beyond 2021.

OneStream version 5.3 was the last version to support the Windows 7 operating system. Windows 7 is no longer supported as a client operating system as of January 14, 2020, in line with Microsoft’s mainstream support policy. 

Schema Update

For OneStream 6.2.0, you are not required to perform a Database Schema Upgrade on the Framework and application databases when upgrading from version 6.1.0 and prior using the OneStream Database Configuration Utility. 

New Features

  • Task Scheduler provides the ability to schedule data management sequences that execute a data management step within the application (6550).

  • Retain Formatting in Selection Styles with the Excel Style Palette now includes a full color palette that you can use to select your style, create a custom style, and hover over existing styles, before you choose a style (19813).

  • Edit Bindings dialog box has been added to the Report Designer dashboard. Use it to view edit bindings, and display the invalid status and apply corrections (20597).

  • Data Inspector functionality has been added to the BI Viewer at both design and runtime that contains two grids that display raw and aggregated data (15942. 21180).

  • Displaying inactive users gives you the ability to create an authorization policy to disable users after a specific amount of logon inactivity, keeping only active users in the system (21010).

  • BI Blend Star Schema Dimension Tables Leveled Hierarchy is for aggregation reporting where parent values reflect the aggregation points. Leveling adds the hierarchy context that is useful in Pivot Grid and custom Dashboard reports (20618).

  • OneStream Database Configuration and Server Configuration utilities have been enhanced with a new user interface that is aligned with the OneStream application and supports the use of high-resolution monitors (15305).

Requested Enhancements

  • WPF Sever Config Utility: Web Server Configuration Settings dialog has been added. An ellipsis button opens a separate dialog and shows through a property grid. The XML code matches the old utility and works the same. (15305)

  • A new BRApi has been added to get security group information for a specified user. (20232)

  • Modified Stage View query for performance optimization. (18911, 21577)

  • You can create a session using a different application with new BRApi function. (22579)

Fixed

  • When opening a Workbook that contains OneStream Formulas/Cube Views/Quick Views directly from the file system before opening a blank Excel workbook and logging into the OneStream Excel Add-In, the user doesn’t receive a “Cannot run the macro ‘XFInternalSetConnectionInfo’ error. (5024)

  • Workflow Profile grid view show data or drop-downs for fields that have selectable values. (21675)

  • Embedded sub reports generate additional functioning reports. (20929)

  • Report Designer and Studio no longer shows an invalid binding that should not be there. (20911)

  • OneStream Application loads enhanced to support XML files coded as UTF-16LE. (20523)

  • Enhanced the SQL Table Editor to support floating point and double precision data type fields. (22046)

  • When adding a new Complex Expression or editing an existing one, it functions correctly and consistently based on how you open the Expression Editor dialog box. (21066)

  • Time description and short time description of W63 displays correctly. (20442)

  • Excel macro performance has been enhanced when converting XFGetCell to values. (22589)

Known Issues

  • If you click the Data Inspector in BI Viewer or BI Designer, and minimize in print preview, the application freezes. (20903)

  • In Preferences > Culture, BI Viewer can crash when you change the culture from English. (22601)

  • If you create a custom selection style for a cube view with a border or pattern, the color won’t show in the palette, but it will show in the cube view. (21638)

  • In Dashboard studio designer, the data member does not display the data set fields tree on order to allow a section of a row. (22213)

  • When launching the palette, the border properties can’t be previewed in the dialog. This is a technical limitation within Excel. (20199)

  • If running on Windows 2012 R2, requestFiltering removeServerHeader="true" needs to be removed from the config files, as it is only supported for IIS 10. (18662)

  • “Object reference not set to an instance of an object” error displays when a spreadsheet component is referenced in an embedded dashboard when a different tab is selected before going back to the Dashboard tab. (21620)

  • Using Cube View Excel Style Formatting, if more than one row or column returned uses the same label, then only the first occurrence will support the style. Unique styles are required. (17287)

  • Non-Administrator Application Pool User Returns Errors for PerfLib and PerfNet When Recycling IIS and Background Intelligent Transfer Service When Using "Recycle App Pool". (14336)

  • If your security protocols do not allow use of the click once client and you use the desktop client to install, the first time the install is performed as a silent install. If you need to upgrade, uninstall does not work. There is a workaround. (11184)

  • The XFDox Builder may not correctly update Table of Contents page numbering when content is added. (10704)

  • Users editing dimension hierarchies through the Silverlight-based web interface may experience an intermittent issue where the Dimension Library page becomes unavailable. Use of the OneStream Windows Application is the recommended solution for application management to avoid this situation. (10274)

  • Viewing Dashboards in the Silverlight Web Browser, which are designed to contain more than six levels of nested Dashboards, may not render as expected. Users encountering this issue should use the OneStream Windows Application interface as a solution. (10136, 10102)

  • Excel Extensible Documents may not retain the margin and print area formatting when assigned to a OneStream Book of reports. (9052)

  • Monitor displays set for over 125% may impact complex Dashboards by partially hiding content. The Windows Application content zoom is recommended. The optimal display is 1920 x 1080 resolution. For the Windows desktop application, we recommend setting the scale to 100% and using the zoom functionality to zoom in. This is especially helpful in dashboards such as People Planning and Reporting Compliance. (6255)

  • To have SSL security configured between the OneStream Application and Web Servers, Application Pools must use a local administrator account rather than a domain account for On-Prem. (4603)

  • When navigating to a Linked Cube View, the drill-down feature may not properly open a source document. (3056)

  • The Report Preview may Error in a Cube Views that are Sharing Rows/Columns and they both have the same row or column names. (2651)

  • If Process Selection Changed for Inserts is set to False and you add a new row, the lower dashboard refreshes and the time updates. (18458)

  • In Cube Views with nested expansions the Member Name and Description wraps when viewed as a report. (16083)

  • OneStream Desktop Application does not open in Windows Native version if MS Edge browser with Edge Chromium has support for Clickonce disabled. You must enable Edge Chromium support for Clickonce. (19757)

  • Text wrapping will not work with a Cube View which uses Cube View Extender Rules. It causes Reports to incorrectly format data. (20635)

Contact Support

To contact OneStream support, first register at our support site http://support.onestreamsoftware.com and then email support@onestreamsoftware.com.